UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TdNbeL5ks9kdf6i5W9E6yoMhrkG8MemT8EFZLi2TFAE='
WHERE
key_id = '17412fa7b3d46015cba187e635be7219f0394ed193c0bdcec1804d038f0c8520'
AND (
token = 'TdNbeL5ks9kdf6i5W9E6yoMhrkG8MemT8EFZLi2TFAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)