UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3eHlfIyTbdyTacb+boWv2Mre+6JU+YcXlZbC97A3fkg='
WHERE
key_id = '7de8beb270b6d71887a581fa60b32653c3d79535c31101ccc781dec82adb4977'
AND (
token = '3eHlfIyTbdyTacb+boWv2Mre+6JU+YcXlZbC97A3fkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)