UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8prPEbw6psTYIIh2l0vLBP1po61jpMATRxOV+PgQ+/k='
WHERE
key_id = '8fdf36ebea9f4cd96e32423c8d14e4b62cc114c58e8a4fe183ada4e312e73e46'
AND (
token = '8prPEbw6psTYIIh2l0vLBP1po61jpMATRxOV+PgQ+/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)