UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7E+uLsCSvKC+/EOkLDolZWJUovOMrjYAtGl46Nlmaw='
WHERE
key_id = '165793707d2aa85235fad09e089dbfc61631fbd6d6a7cf81a5be3dd28857faf7'
AND (
token = 'K7E+uLsCSvKC+/EOkLDolZWJUovOMrjYAtGl46Nlmaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)