UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4o0sSdt7uJDJ/C4giV+zoQXaPMn95JLqfCCQP3jYqA='
WHERE
key_id = '923c0dd9192d4a9bd15b5014f23eb75a79a2e5a9e33379572fc023d55bdbcb1b'
AND (
token = 'B4o0sSdt7uJDJ/C4giV+zoQXaPMn95JLqfCCQP3jYqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)