UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0w/RK3BXvPuE9Nt5t3vREKndsd9SY3e0ZvffG1Rek+k='
WHERE
key_id = '0cbcf9b3de8b7c33373fa52d687ff6182685092482737471618bc61174859ccc'
AND (
token = '0w/RK3BXvPuE9Nt5t3vREKndsd9SY3e0ZvffG1Rek+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)