UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gCKI4d2bZqpSy53yaeGJuNlXW//ZyvV0YrX5LOe6Yo='
WHERE
key_id = '01b168022fea770db75e2ba4e1523bfbc8753dfb6981620348603a3f2ed23128'
AND (
token = '0gCKI4d2bZqpSy53yaeGJuNlXW//ZyvV0YrX5LOe6Yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)