UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NqnPhI35uIbfsqe9BKBL6IwAVi+eGmVVxinDwwavsU='
WHERE
key_id = 'aa7bf8bf156e7db7989623590d779c080b1024e47a8a6d35364997fe15cafe96'
AND (
token = '3NqnPhI35uIbfsqe9BKBL6IwAVi+eGmVVxinDwwavsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)