UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h5KKEteyrL6Va0izpAGjY8GXPgSxvSAzUS0BIADyWDk='
WHERE
key_id = '8f385f99e0ee0623104a3d81fd870080417aeb88e57919f82ed2033afb857fd8'
AND (
token = 'h5KKEteyrL6Va0izpAGjY8GXPgSxvSAzUS0BIADyWDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)