UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aAN+qsF5z09wYL53O6qViUl0ZURmkvitYU4i5p7DUqY='
WHERE
key_id = '7b1166faa1c3afc7643e2ac65d13760dc1446bfe3562144976bed3de4ed7d63f'
AND (
token = 'aAN+qsF5z09wYL53O6qViUl0ZURmkvitYU4i5p7DUqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)