UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4atY70V+gE6iYvJXNBB9ponOMI54Scd2vrva37a6CLA='
WHERE
key_id = 'c48cf53f6e582028ccb6c622f53a6495e7d552f167b7c6cf5b4a8a782298fdb6'
AND (
token = '4atY70V+gE6iYvJXNBB9ponOMI54Scd2vrva37a6CLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)