UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UiwyVLsYL9PMLJkCkdTE5uGWZhcmlRIEeLJKjkx1oGQ='
WHERE
key_id = '67e3287d7a70ca369e4af88f7e4f0f66ab10d9ea3d698fd4ee1d1d25b2ee71ef'
AND (
token = 'UiwyVLsYL9PMLJkCkdTE5uGWZhcmlRIEeLJKjkx1oGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)