UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YqJ4WzynezNg+ohEaCl02SNUjILV8gFDSf9+mizrtp8='
WHERE
key_id = 'b8ba460b5e86e0006be3b70cf4805eb9766aa98c63170d6ac95abb865a3c07b7'
AND (
token = 'YqJ4WzynezNg+ohEaCl02SNUjILV8gFDSf9+mizrtp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)