UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YzilM8lj7J037wuLQZDfnSkMVDSOVxvDKRVLOAyw1M='
WHERE
key_id = '74810740270883d1f1ec3b37703d6ff8ad795601e2071de72ef41bef357be009'
AND (
token = '1YzilM8lj7J037wuLQZDfnSkMVDSOVxvDKRVLOAyw1M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)