UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XE5QzKyYCPNSshY7j9qY2ErAxGb7Ysfj0Dl8lzR60m4='
WHERE
key_id = '16f57143d3bef8b99e005a7ce2a1ef05efda1b567de60e1517239b72fe74fe3f'
AND (
token = 'XE5QzKyYCPNSshY7j9qY2ErAxGb7Ysfj0Dl8lzR60m4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)