UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ptXPZYKcdUQHL/TWlUY3mXe7VRH4GLdRpT+Ug9hLUc='
WHERE
key_id = '2c30718933c92d743077605034f08a055b6d8133b4794f434fdbf22122cbefdd'
AND (
token = '8ptXPZYKcdUQHL/TWlUY3mXe7VRH4GLdRpT+Ug9hLUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)