UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAqJvcIukPfpv79rU9KZmFp6qyb5TRkm2iRn9rn8mp0='
WHERE
key_id = '378d5e07f880a136bf3f0c4e2bd9984e1ef216ed6e63f7b91689e845f9647ef5'
AND (
token = 'oAqJvcIukPfpv79rU9KZmFp6qyb5TRkm2iRn9rn8mp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)