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