UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c3U0D8HeKmZapABKFvsUWunP3yiLLcj3yIEuXuQGXs4='
WHERE
key_id = 'c39ac003eedc8af1a5a4ae0822b36a6e55ce7f7815605522b263fb9f90c2003e'
AND (
token = 'c3U0D8HeKmZapABKFvsUWunP3yiLLcj3yIEuXuQGXs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)