UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJgpiM354WcBH8vPkQWm4EeGqr0+9aqXW6EW26UM+vk='
WHERE
key_id = 'a1b418afe9ab320de00f09b0713cb5859187ad7ff8555ad07e116e4955c35790'
AND (
token = 'pJgpiM354WcBH8vPkQWm4EeGqr0+9aqXW6EW26UM+vk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)