UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPFUlGCMjaw8FfQRFmlDXbEIU5lRdO+cHLaghrVTrVY='
WHERE
key_id = 'a143d3dd4745731c2365b80b58ce71d6e871369a61fab687eb35b147f2909155'
AND (
token = 'XPFUlGCMjaw8FfQRFmlDXbEIU5lRdO+cHLaghrVTrVY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)