UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p/IabHvgE1hjVn3/LZq+EZtf68VOYwOU9UI15lHCeag='
WHERE
key_id = 'e6bc23dad4df46ff30db68f74cbf117f180845dc14725a5b8c20bd7524fdc09f'
AND (
token = 'p/IabHvgE1hjVn3/LZq+EZtf68VOYwOU9UI15lHCeag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)