UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIMJS05a7XDTrv1fRrRO0iZvmBOUIcha0b+X2gsvdUg='
WHERE
key_id = '09e765f1cd78e2f2e274325a2ed6893151e72e74c33420ee3e968942e74a0863'
AND (
token = 'hIMJS05a7XDTrv1fRrRO0iZvmBOUIcha0b+X2gsvdUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)