UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZI4ywFxGRe72nCAOqQXQpVmXXdxNJVyQ0EME5KvYkk='
WHERE
key_id = '2d4b26d26f80aa26f144945df25076ebeaafd3394d7835ae64ebe32bdc3fa554'
AND (
token = 'PZI4ywFxGRe72nCAOqQXQpVmXXdxNJVyQ0EME5KvYkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)