UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IkSlZIa0uH6PfxOoRHbH1KffQ0tVal3Yjn1kzlU2PL8='
WHERE
key_id = '0e7f6e267ee9543c3a3f890f5be2d4e38908d0058b6e1e1fe1335bebf0ea3f96'
AND (
token = 'IkSlZIa0uH6PfxOoRHbH1KffQ0tVal3Yjn1kzlU2PL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)