UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DhDNSjG5yx+a8mX3qbsh2kWQzPBte77klMaGCdUNRK8='
WHERE
key_id = '8ca9428e1ad1a63471cfdc3fd623ff2897a7aef46b548f9482c1d43d42c50bde'
AND (
token = 'DhDNSjG5yx+a8mX3qbsh2kWQzPBte77klMaGCdUNRK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)