UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+hKSW2hh5jNAQjHqVHsvd10isckhnafLvNFPjsiRG1o='
WHERE
key_id = '2d03e8373e298e5255520afb36e19980c3e479fa1eb738da65d6ff256277776e'
AND (
token = '+hKSW2hh5jNAQjHqVHsvd10isckhnafLvNFPjsiRG1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)