UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKE5HJnPmm67uC6kr3Zo+AenuHiSu0oruitT4Huy2zQ='
WHERE
key_id = 'cedb3ae4b9f52f1e2ef6f47b0ee55093abf1678839842fdfc0e8e6639ae8f7ab'
AND (
token = 'pKE5HJnPmm67uC6kr3Zo+AenuHiSu0oruitT4Huy2zQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)