UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sG3Givsllp35c5FhXkcDCeNABwKKW9XseEVqGqQhtSc='
WHERE
key_id = '8badb1c734cdf79974d0db99e4548d6cd6923e8cc04b44177521b1f45cf4568c'
AND (
token = 'sG3Givsllp35c5FhXkcDCeNABwKKW9XseEVqGqQhtSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)