UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mbPUyfAUkgS73eb7A3pT9xkCv6P9VLyH4i6TjEz4dxs='
WHERE
key_id = '8e840db49b875c662ccf1e8495d053d9d205a966c4b09c16256199acd1dba983'
AND (
token = 'mbPUyfAUkgS73eb7A3pT9xkCv6P9VLyH4i6TjEz4dxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)