UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4idzrVLJDxBPFn9QuC1tEJH8uMa17VWS7mSQWet5lzA='
WHERE
key_id = '865e5c9e835d43365a1cf75ddc2d254aef2f0912ccdc8f3c7d93443dc2a1ccde'
AND (
token = '4idzrVLJDxBPFn9QuC1tEJH8uMa17VWS7mSQWet5lzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)