UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WmkCYupeKxo0O+R+awaQSlBIWC+gJR6dx33kFMsqLw='
WHERE
key_id = '8f3e2a2dfae9d073e25a1f75e75f91e55b85658aa4176467d60f7b46040f6463'
AND (
token = '7WmkCYupeKxo0O+R+awaQSlBIWC+gJR6dx33kFMsqLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)