UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LBwT6rmaAuonL5q7s3Tk1pEY5kivteqAti/VYe1XvN4='
WHERE
key_id = '22e7e871b5d083b4e5b938fa9295b93bc24e848bedc5716a8d9497e27db2a54b'
AND (
token = 'LBwT6rmaAuonL5q7s3Tk1pEY5kivteqAti/VYe1XvN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)